home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_SALESPIPELINE.ACCDT_1043 / template / database / objects / queryForecastChartSource.txt < prev    next >
Text File  |  2006-11-12  |  5KB  |  139 lines
  1. ∩╗┐Operation =1
  2. Option =0
  3. Where ="(((Opportunities.Closed)<>True))"
  4. Begin InputTables
  5.     Name ="Opportunities"
  6.     Name ="Customers Extended"
  7.     Name ="Employees Extended"
  8. End
  9. Begin OutputColumns
  10.     Expression ="[Employees Extended].[Employee Name]"
  11.     Expression ="[Customers Extended].[Contact Name]"
  12.     Alias ="Toegewezen aan"
  13.     Expression ="Opportunities.Employee"
  14.     Expression ="Opportunities.[Est Closed Date]"
  15.     Alias ="Prognosewaarde"
  16.     Expression ="[Est Revenue]*[Probability]"
  17.     Expression ="Opportunities.Closed"
  18.     Expression ="Opportunities.Category"
  19.     Expression ="Opportunities.Rating"
  20.     Expression ="Opportunities.Employee"
  21.     Expression ="Opportunities.Customer"
  22. End
  23. Begin Joins
  24.     LeftTable ="Opportunities"
  25.     RightTable ="Customers Extended"
  26.     Expression ="Opportunities.Customer=[Customers Extended].ID"
  27.     Flag =2
  28.     LeftTable ="Opportunities"
  29.     RightTable ="Employees Extended"
  30.     Expression ="Opportunities.Employee=[Employees Extended].ID"
  31.     Flag =2
  32. End
  33. dbBoolean "ReturnsRecords" ="-1"
  34. dbInteger "ODBCTimeout" ="60"
  35. dbBoolean "OrderByOn" ="0"
  36. dbByte "Orientation" ="0"
  37. dbByte "DefaultView" ="2"
  38. dbBoolean "FilterOnLoad" ="0"
  39. dbBoolean "OrderByOnLoad" ="-1"
  40. dbLongBinary "DOL" = Begin
  41.     0x0acc0e5500000000f9383f4de4b69b4a9c3f4756a64d5def0000000037febaef ,
  42.     0x570ae34000000000000000004f00700070006f007200740075006e0069007400 ,
  43.     0x6900650073000000000000007233de6d5919c2438b87550d8a7eadfd00000000 ,
  44.     0xb533c2ef570ae340010000004029283443007500730074006f006d0065007200 ,
  45.     0x7300200045007800740065006e00640065006400000000000000c01ef7baa3de ,
  46.     0x7046af332f94cad59338000000005002eaef570ae34001000000402928344500 ,
  47.     0x6d0070006c006f007900650065007300200045007800740065006e0064006500 ,
  48.     0x64000000000000007bc5ba4edcaf424d914a1cf94a0102d507000000077b9892 ,
  49.     0xcfc3d049b556ef9f4d2bb585410073007300690067006e006500640020005400 ,
  50.     0x6f00000000000000174a1bf587a3c74aa96a761acb33393d07000000077b9892 ,
  51.     0xcfc3d049b556ef9f4d2bb58546006f0072006500630061007300740020005600 ,
  52.     0x61006c00750065000000000000008b22150c5ba9c9468e86487f5a2b7f5e0700 ,
  53.     0x0000c01ef7baa3de7046af332f94cad5933845006d0070006c006f0079006500 ,
  54.     0x650020004e0061006d00650000000000000065e7a97369bcc04fbf9789799fc1 ,
  55.     0x0c22070000007233de6d5919c2438b87550d8a7eadfd43006f006e0074006100 ,
  56.     0x6300740020004e0061006d0065000000000000005c031b4e60997c46a462f141 ,
  57.     0x2eef821307000000f9383f4de4b69b4a9c3f4756a64d5def45006d0070006c00 ,
  58.     0x6f00790065006500000000000000040d384ef8081f46b3fad4483992f1180700 ,
  59.     0x0000f9383f4de4b69b4a9c3f4756a64d5def450073007400200043006c006f00 ,
  60.     0x730065006400200044006100740065000000000000008e0b52a7e7b4b14d8c20 ,
  61.     0xcb5758a54a8307000000f9383f4de4b69b4a9c3f4756a64d5def450073007400 ,
  62.     0x200052006500760065006e0075006500000000000000cd478d1676adb944b051 ,
  63.     0x02a946a255c907000000f9383f4de4b69b4a9c3f4756a64d5def500072006f00 ,
  64.     0x62006100620069006c006900740079000000000000005487861bbbabad48a605 ,
  65.     0xc3d158d6055407000000f9383f4de4b69b4a9c3f4756a64d5def43006c006f00 ,
  66.     0x730065006400000000000000a94d50d894af5443be31ffec1b25ae7807000000 ,
  67.     0xf9383f4de4b69b4a9c3f4756a64d5def430061007400650067006f0072007900 ,
  68.     0x000000000000e4709dbdbb7b1f498cb286942016f3fe07000000f9383f4de4b6 ,
  69.     0x9b4a9c3f4756a64d5def52006100740069006e006700000000000000e2112b83 ,
  70.     0x27bc3644bb22fd7687e814c307000000f9383f4de4b69b4a9c3f4756a64d5def ,
  71.     0x43007500730074006f006d00650072000000000000004b29152c01164844a235 ,
  72.     0xaa9efb306df7070000007233de6d5919c2438b87550d8a7eadfd490044000000 ,
  73.     0x0000000059084f107407674dbd2935ac5a4fb9f707000000c01ef7baa3de7046 ,
  74.     0xaf332f94cad59338490044000000000000000000000000000000000000000000 ,
  75.     0x00000c000000040000000000000000000000000000000000
  76. End
  77. dbByte "RecordsetType" ="0"
  78. dbBinary "GUID" = Begin
  79.     0x077b9892cfc3d049b556ef9f4d2bb585
  80. End
  81. dbBoolean "TotalsRow" ="0"
  82. Begin
  83.     Begin
  84.         dbText "Name" ="Toegewezen aan"
  85.         dbLong "AggregateType" ="-1"
  86.         dbBinary "GUID" = Begin
  87.             0x7bc5ba4edcaf424d914a1cf94a0102d5
  88.         End
  89.     End
  90.     Begin
  91.         dbText "Name" ="Prognosewaarde"
  92.         dbLong "AggregateType" ="-1"
  93.         dbBinary "GUID" = Begin
  94.             0x174a1bf587a3c74aa96a761acb33393d
  95.         End
  96.     End
  97. End
  98. Begin
  99.     State =0
  100.     Left =0
  101.     Top =0
  102.     Right =799
  103.     Bottom =612
  104.     Left =-1
  105.     Top =-1
  106.     Right =784
  107.     Bottom =337
  108.     Left =0
  109.     Top =0
  110.     ColumnsShown =539
  111.     Begin
  112.         Left =48
  113.         Top =12
  114.         Right =192
  115.         Bottom =156
  116.         Top =0
  117.         Name ="Opportunities"
  118.         Name =""
  119.     End
  120.     Begin
  121.         Left =240
  122.         Top =12
  123.         Right =384
  124.         Bottom =156
  125.         Top =0
  126.         Name ="Customers Extended"
  127.         Name =""
  128.     End
  129.     Begin
  130.         Left =432
  131.         Top =12
  132.         Right =576
  133.         Bottom =156
  134.         Top =0
  135.         Name ="Employees Extended"
  136.         Name =""
  137.     End
  138. End
  139.